cap cd "/Users/ddgueorg/Dropbox/Papers/China - HK Protests/Data"
import excel "Newspaper_HK_final_brief.xlsx", sheet("Sheet1") firstrow clear
g articles=1
collapse (sum) articles violence independence both, by(date)
gen order=_n
generate date_num = date
format date %tdm_d
g v_per=violence/articles
g _per=both/articles
twoway (line violence date) (line both date, lpattern(dot) lwidth(thick) lcolor(black)) if order>14 & order<86, xline(21731 21751 21765 21773, lpattern(dash) lwidth(thin) lcolor(red)) ///
legend(size(small) order(1 "Violence" 2 "Violence + Seperatism") rows(2) position(11) ring(0)) xlabel(21701 21731 21751 21765 21773 21793, angle(forty_five)) xtitle(, size(zero)) ytitle(No. of Articles)
